Use this query to display invalid records (SQL Server): Select [GLAccGLCaption].* from [GLAccGLCaption] INNER JOIN [GLCaption]ON ([GLAccGLCaption].[GLCaptionId] = [GLCaption].[Id] and [GLAccGLCaption].[DBId] = [GLCaption].[DBId])where Not [GLAccGLCaption].[GLCaptionPlanId] = [GLCaption].[GLCaptionPlanId]Union AllSelect [GLAccGLCaption].* from [GLAccGLCaption] INNER JOIN [GLCaption]ON ([GLAccGLCaption].[DGLCaptionId] = [GLCaption].[Id] and [GLAccGLCaption].[DBId] = [GLCaption].[DBId])where Not [GLAccGLCaption].[GLCaptionPlanId] = [GLCaption].[GLCaptionPlanId]Union AllSelect [GLAccGLCaption].* from [GLAccGLCaption] INNER JOIN [GLCaption]ON ([GLAccGLCaption].[CGLCaptionId] = [GLCaption].[Id] … Continue reading Query: Select GLAccGLCaption where the Caption and the CaptionPlan do not match